﻿CREATE TABLE [dbo].[FilteredEvents] (
    [FilteredEventID] INT           IDENTITY (1, 1) NOT NULL,
    [MeterNumber]     NVARCHAR (50) NOT NULL,
    [MeterVendorID]   NVARCHAR (50) NOT NULL,
	[MeterHeadEndID]  NVARCHAR (50) NOT NULL,
    [TimeStamp]       DATETIME      NOT NULL,
    [EventType]       NVARCHAR (50) NOT NULL,
    [Reading]         FLOAT         NOT NULL,
    [Temp]            FLOAT         NOT NULL,
    [Code]            NVARCHAR (50) NOT NULL,
    [Status]          NVARCHAR (50) NOT NULL
);
